cmActions 
Logical Entity Name  cmActions 
Default Table Name  cmActions 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

cmActions Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Code    char(8)  NO 
 
Descrip    varchar(50)  NO 
 
cmObjectID(FK)    int  NO 
 
cmObjectEventID(FK)    int  NO 
 
StatusID    int  YES 
 
TemplateTriggerID    int  NO 
 
AmLeadTypeID    int  NO 
 
cmEventTypeID    int  NO 
 
cmTemplateID    int  NO 
 
cmTemplateAssignTo(FK)    int  NO 
 
SyStaffID(FK)    int  NO 
 
TimeFrame    int  NO 
 
TimeUnit    smallint  NO 
 
Before    bit  NO 
 
cmDateID(FK)    int  NO 
 
Active    bit  NO 
 
Required    bit  NO 
 
SystemCode    bit  NO 
 
UserID    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
cmActionsID(PK)    int  NO 
 
SyCampusGrpID    int  YES 
 
AssignToCode    char(1)  YES 
 
SyStaffGroupID(FK)    int  YES 
 
CmDocTypeID(FK)    int  YES 
 
PreviousStatusID    int  YES 
 
ProcessTaskType    char(1)  YES 
 
CmDocTypeListID(FK)    int  YES 
 
CmDocTypeIDs    varchar(4000)  YES 
 

cmActions Primary and Unique Keys 
Key Name  Key Type  Keys 
cmActions_cmActionsID_U_C_IDX  PrimaryKey  cmActionsID 

cmActions Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
cmDate  Non-Identifying  One To Zero or More  FK_cmActions_cmDateID_cmDate_cmDateID      cmDateID  NO  YES 
CmDocType  Non-Identifying  Zero or One to Zero or More  FK_CmActions_CmDocTypeID_CmDocType_CmDocTypeID      CmDocTypeID  NO  YES 
cmObjectEvent  Non-Identifying  One To Zero or More  FK_cmActions_cmObjectEventID_cmObjectEvent_cmObjectEventID      cmObjectEventID  NO  YES 
cmObject  Non-Identifying  One To Zero or More  FK_cmActions_cmObjectID_cmObject_cmObjectID      cmObjectID  NO  YES 
cmTemplateAssignTo  Non-Identifying  One To Zero or More  FK_cmActions_cmTemplateAssignTo_cmTemplateAssignTo_cmTemplateAssignToID      cmTemplateAssignTo  NO  YES 
SyStaffGroup  Non-Identifying  Zero or One to Zero or More  FK_cmActions_SyStaffGroupID_SyStaffGroup_SyStaffGroupID      SyStaffGroupID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_cmActions_SyStaffID_SyStaff_SyStaffID      SyStaffID  NO  YES 
CmDocTypeList  Non-Identifying  Zero or One to Zero or More  FK_cmActionsCmDocTypeListID_CmDocTypeListCmDocTypeListID      CmDocTypeListID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
CMActionsChangesTo  Non-Identifying  One To Zero or More  FK_CMActionsChangesTo_CmActionsID_CmActions_CmActionsID        NO  YES 
CmActionsFundSourceDetail  Non-Identifying  One To Zero or More  FK_CmActionsFundSourceDetail_CmActionsId_CmActions_CmActionsId        NO  YES 
CmDocument  Non-Identifying  One To Zero or More  FK_cmDocumentCmActionsId_cmActionsCmACtionsId        NO  YES 

cmActions Check Constraints 
Check Constraint Name  CheckConstraint 

cmActions Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

cmActions Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.TaskAddTrigger 
NO       
Physical (Microsoft SQL Server)
dbo.cmActions 
NO       

cmActions Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Documents 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Career Services 

cmActions Data Movement Rules 
Name  Type  Rule Text/Value